Create Date Dimension , separate dimension from main table 8

Create Time table and separated dimensions from main table


Create Time table


Create dim table



When your model already has a date table and you need an additional date table, you can easily clone the existing date table. It's the case when date is a role playing dimension. You can clone a table by creating a calculated table. The calculated table expression is simply the name of the existing date table.

click below link for more info

https://docs.microsoft.com/en-us/power-bi/guidance/model-date-tables